﻿DELETE FROM tbMenu



insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (1,'1',N'&Hệ thống','hethong',1,null,'tools');
insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (2,'1',N'&3. Tham số hệ thống','thamsohethog',5,null,'tools');
insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (3,'2',N'&Danh mục','bangma',1,null,'dbs');
insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (4,'1',N'&2. Quản lý người dùng','QuanlyUser',4,'Users.UsersListForm, Users, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null','suport_M_online');
insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (5,'2',N'&1. Danh sách công việc','WorkList',2,'WorksList.WorkList, WorksList, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null','file_edit');
insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (11,'1',N'&Thoát','Exits',12,null,'LOG_OFF');
insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (12,'1',N'&1. Đăng nhập','Login',2,'Worker.LoginForm, Worker, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null','');
insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (13,'1',N'&4. Quản lý chi nhánh','BranchCode',6,'BranchCode.BranchCodeListForm, BranchCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null','home');
insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (14,'1',N'&9. Cập nhật chương trình','UpdatePro',10,'Worker.UpdateForm, Worker, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null','software_update');
insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (15,'1','\-','Line',3,null,'');
insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (16,'1','\-','Line',11,null,'');
insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (17,'1','\-','Line',9,null,'');
insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (18,'2','\-','Line',3,null,'');
insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (19,'2',N'&2. Danh mục nhóm vật tư','MaterialGroupList',4,'Material.MaterialGroup, Material, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null','item1');
insert into tbMenu([Id],[Group],[Caption],[MenuName],[MenuLevel],[Click],[Icon]) values (20,'2',N'&3. Danh mục vật tư','MaterialList',5,'Material.MaterialListForm, Material, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null','organize');


GO
 